Executive Dash - Summary of Changes

V12.4.1 January 2010
- Task 1661: When managing connections added message if QDConnections file doesn't exist or user doesn't have access to it. 
- Task 1664: Prevented connections file path from overlapping purple button on Connection Management panel. Added hover tooltip to display full path name for connections file.
- Task 1680: Corrected error when save query to a location other than the default query location. 
- Task 1681: Corrected process to NOT allow saving a query by a different name.
- Task 1686: Changed names of license types: Standard to Evaluation, Professional to Standard, Enterprise to Professional.
- Task 1687: Added ability to manually register. NOTE: Manually registered users do NOT have access to the Query Exchange component.
- Task 1688: Global Only: Added ability to disable an Evaluation license type after six months.
- Task 1690: Enhanced to delete the PersonalSettings.xml when a user is unregistered. 
- Task 1691: Updated contents of license agreement.
- Task 1695: Changed links for purchasing EDash. 
- Task 1697: Global Only: removed access to Publish and Search Online buttons in Query Designer when working offline.
- Task 1698: Added User Code component to manual license key. Added display of UserID and User Code to Online Registration panel.
- Task 1706: Added ability to assign license type to manual license key. 
- Task 1709: Corrected an exception error during an upgrade installation, when the QDConnections or Query EDQ files reside in a network drive location.

V12.3.6 January 2010
- Task 1646: Corrected registration error on Windows Server 2008 where user's Window ID is not being passed to EDash. 
- Task 1648: ADA/CR Only: removed EULA panel from install process.
- Task 1675: MBA Only: updated MBA language.dll with correct product name (Mokum Business Analyser).
- Task 1677: Global Only: removed requirement to register as a publisher. 

V12.3.5 January 2010
- Task  752: Added late binding in XLA to allow for DM automation. 

V12.3.4 January 2010
- Task 1637: Corrected issue with Online Timeout setting in .INI file.

V12.3.1 December 2009 
- Task     : Modified install program to install Framework 3.5 and VSTO if not currently on the PC.   
- Task  312: Corrected tabbing order on the EXD and EXQ Formula Assistant tabs. 
- Task  327: Added filtering functionality on entry level (information, warning, error) to Log Viewer panel. 
- Task  339: Added function to allow assigning field attribute (i.e. text vs. numeric) to calculated fields.
- Task  442: Licensing: enhanced licensing to control usage of various EDash components (Standard, Professional and Enterprise licenses).  
- Task  444: Added Sort Order field to Field List window to control order of sorting records in query.
- Task  445: Added new button to delete all relationships between all tables within the query. 
- Task  452: Corrected values in the Total Type dropdown list for Formula Assistant when an alternate Total Field is used.
- Task  470: For Progress (SQL92) corrected ability for EXQ formula to summarize on a field that is not the default field.
- Task  545: After a new query is saved, modified to display the newly created query in the most recently used (MRU) file list.
- Task  555: For Progress (SQL92) corrected an error when smart parms is blank and when table or field name contains a dash (-). 
- Task  558: Corrected a SQL error where the FROM statement was omitted when a substring of a different table was already processed in the query.
- Task  664: Corrected Definition button in Designer to properly place Query Textual Definition text in notepad. 
- Task  665: Modified "Refresh Query Catalog" verbiage to "Refresh Queries" on EDash menu, toolbar and ribbon options. 
- Task  667: Corrected to properly display selected subdirectory even when subdirectory does not contain any queries. 
- Task  709: Corrected spelling error on Set Default dialog box within Designer. 
- Task  792: Corrected a SQL error querying an Access database when spaces are in the table name.
- Task  812: When open Formula Assistant modified to default worksheet to current sheet instead of SHEET1.
- Task  833: Corrected access to Report Designer when using Explorer File System View.
- Task  858: When working in File System view modified navigation to retain focus on current folder when open/close a query.
- Task  985: Added Slide bars to Ad Hoc Query panel for longer ad hoc definition and query names.
- Task 1068: When change query description modified to not require rekeying of entire description. 
- Task 1094: Modified to properly refresh the query title when in File System view. 
- Task 1095: Corrected the Refresh button on the Table Selector panel to look for files in the public documents/shared documents folder area. 
- Task 1102: Added new User Settings file to control Online Access, Registration Key and Online Access Web Address.
- Task 1103: Added new Online tab in Settings for controlling online processing; removed obsolete field, Enable Application Security.  
- Task 1104: Corrected program to trim the description and cleanup a file with the bad characters in the table description.
- Task 1105: Global Only: added function to Formula Assistant to access Query Exchange for downloading queries.
- Task 1106: Registration: added new process for registering Executive Dash. 
- Task 1268: Corrected an invalid index error which prevented ad hoc drill downs from functioning properly in Excel. 
- Task 1279: Corrected the EXD formula function to support parms exceeding 255 characters.
- Task 1294: Changed field names to upper case to handle case sensitive SQL databases. 
- Task 1295: Made change in EDash to enable Spreadsheet Writeback to utilize EDash managed connections. 
- Task 1304: Global Only: added Purchase button to Executive Dash ribbon in Excel (not visible if Enterprise license).
- Task 1305: Recreated Excel 2007 Ribbon in VS 2008 to comply with design requirements.
- Task 1306: Added View Registration button to Executive Dash ribbon in Excel and in Query Designer. 
- Task 1307: Added Manage Connections option to the Executive Dash menu and ribbon in Excel. 
- Task 1308: Global Only: added Purchase menu item to EDash menu (not visible if Enterprise license).
- Task 1309: Corrected all formula programs to support parameters exceeding 255 characters.
- Task 1310: Global Only: enhanced install process to include functionality for Registration, Connections Management, Query File Location and ERP selection.
- Task 1311: Added a new sample database (Northwinds) with supporting query files.
- Task 1312: Enhanced the install process to automatically enable the EDash add-in in Excel and to install the Executive Dash custom ribbon.
- Task 1314: Redesigned Connection Management panel, added SAP connection type, added ability to test before save, and added ability to change the connections file location from the panel.  Added delivery of SAP Transport folder (contains component for connecting to SAP database).
- Task 1315: Registration: added ability to register product from within Excel or Query Designer. 
- Task 1316: Global Only: added ability to register product during the installation process. 
- Task 1317: Registration: enabled process to retrieve existing registration data; if no connection made to web then message issued and limited query usage.
- Task 1318: Registration: added required and optional fields to registration process. 
- Task 1320: Registration: added license verification process (email delivered with response required).
- Task 1321: Registration: added ability to release a license key and unregister a user. 
- Task 1348: Added F5 as a shortcut to Execute All Records within Query Designer. 
- Task 1359: Branded Executive Dash for Bottomline - Cash Reporting.
- Task 1376: Corrected display of Context menu when right click on Excel 2007 table. 
- Task 1388: Changed order of function keys on AS/400 Login panel. 
- Task 1397: Corrected tabbing order on AS/400 Login panel.
- Task 1406: Global Only: added buttons to Query Designer to access Query Exchange for downloading or publishing queries.
- Task 1407: Branded Executive Dash for Mokum - Business Analyser.
- Task 1412: Added validation to prevent entry of duplicate connection names. 
- Task 1443: Branded Executive Dash for Bottomline - Active Data Analyzer.
- Task 1469: For new installs only do not install EXQLMAST.mdb (in prep for shift away from catalog view).
- Task 1483: Enhanced search functionality on Tables panel for SAP connection types (search on file name and/or description).
- Task 1488: Corrected to always default &LIB in Library field on Tables panel for iSeries connections. 
- Task 1493: Global Only: added new panel when open Excel allowing access to tutorial and startup tips.  Added new option, Show Startup Tips in Excel, in Settings to control display of the panel.   
- Task 1495: Modified to enable Executive Dash to function properly in Windows7 Operating system; added display of Connection and File Size to Explorer File System pane.
- Task 1498: Modified to ignore any previous license bypassing.
- Task 1502: Added a Save Confirmation panel when exit the Connection Management panel without saving changes. 
- Task 1506: Added ability to copy the connection file to different location from within the Connection Management panel.
- Task 1530: Added Proxy Server settings to support licensing and Online functionality.	
- Task 1554: MBA Only: Added MFA Distributor options to MBA custom Excel ribbon.
- Task 1567: Added new Web Request tab in Settings for trouble-shooting internet connectivity issues.
- Task 1573: Corrected error in Formula Assistant when not using EN-US locale and not using Mixed Regional Settings.
- Task 1609: Added Online Timeout option to Settings Online tab to control web request timeout setting.
- Task 1618: Set Login button as default button on AS/400 Login panel. 

V12.1.2 February 2009
- Task 900: Modified to properly close DSN connection after execution with designer.

V12.1.1 October 2008
- Task  41: Modified system to display and store the field type; allow user to change handling of field type primarily for Calc fields
- Task  97: Added support for detail to SHELL an external program, manual generate, use the format: SHELL<RETURN>,Notepad.exe <RETURN>,&PARM01.  
- Task 255: Corrected Import Top X query error.
- Task 310: Corrected action in EXD to cell, prevents fill down if 0 or 1 record returned.
- Task 311: Removed obsolete objects from Program files.
- Task 318: Allow smart parms to contain a value list equivalent to the Excel cell character content maximum (1024).  
- Task 319: Correction to clearing ranges when Excel 2007 list objects is enabled and using EXD with starting cell or range
- Task 468: Corrected issue with second join in SQL 92 Progress in builder.
- Task 471: Added ability to select/run an EDQ file from a directory or a default directory(new setting) and not contained in the Query Catalog. Effects EXQ,EXS,EXI,EXD
- Task 479: SQL Server connection queries: Added the use of &PARM01 as a parameter in the Change Database of a SQL server table.  Available after a &PARM01, regular parameter, is created.
- Task 502: EXD text file clearing.
- Task 503: Corrected action when EXD to range or table contains a fill down number - disregarded correctly.
- Task 584: Added support for Ad-hoc queries in filesystem view.
- Task 586: Added setting to Enforce file system view, is the default upon install.
- Task 593: Corrected action of EXD to 2007 table with 0 records, clears columns up to number in query leaving formulas to the right in the table in tact.
- Task 650: EDash simple upgrade process for old queries.
- Task 659: Corrected an issue with brackets on smart parms with calculated field when using an *
- Added Sort Order field to Field List window to control order of sorting records in query.
- Added functional buttons for EXDRow, User, WindowsUser to the Misc tab on the Builder.
- Added Save As functionality when using File System View.
- Modified navigation on Tables panel to automatically close when table is added to the query. 
- Corrected issues where SQL parm01 used as database for table and smart parm used on field and * supplied, to be tested by M.H.
- Added the description and last modified to the query xml file; removed dsofile.dll.
- Correction to loading queries in formula assistant with no auto generated SQL.
- Correction to EXQ of queries with no auto generated SQL.
- Correction to add field descriptions as alias with new fields, type and sort order from .11.
- Correction to save non auto generated SQL when leaving the box.
- Correction to location of temp.edq when running queries from the designer now in public structure username_temp.edq.
  
V11.3.9 August 2008
- Task 543: Query Designer maintains previous state, maximized, size and location on screen after closing and re-opening.

V11.3.8 August 2008
- Task 533: New user interface for Query Designer
- Task 534: Added file browser to the Formula Assistant
- Task 535: Moved location of the tables cache files to public folder structure in Application Data.
- Task 536: Corrected logging error with iSeries connections when no password is specified for EXQs or EXDs. 
- Task 537: Moved location of reports generated in the query designer and copied the sample.repx to public folder structure.
- Task 538: Added new Explorer File System view, including added new option on Settings panel for assigning the Default folder for EDQ files.
   
V11.3.5 July 2008
- Task 443: Auto Gen check switch - add prompt to confirm whether or not to retain data.
- Task 446: Fixed the %EXDROW% keyword for used in EXD's with ranges and tables.
- Task 453: Window anchoring corrected.
- Task 454: Corrected processing for iSeries fields with "#" in the field name.

V11.3.4 July 2008
- Task 317: Correction to Access database and join on multiple fields with blanks or spaces or # in the field name
- Task 378: Error using Query Detail on an EXD formula with more than one parameter.
- Task 410: Results Container errors on dates when try to group by or Subtotal.
- Task 429: EDash Add Field Desc as Aliass clearing existing aliases with blank.

V11.3.3 July 2008
- Task 428: Correction to ProgressSQL92 handling of PUB.tables with dashes in the names.  This corrects the quoting issue

V11.3.2 June 2008 
- Task 404: Added fix option to settings to enable or disable Excel 2007 list objects, was producing an error with some Excel 2000 versions

V11.3.1 April 2008
- Task  42: Added/Corrected ability to Query Detail on EXD formulas
- Task  50: Query name entry field restricted to 34 characters
- Task  98: Corrected replication of ad-hoc listing when deleting an ad-hoc query
- Task 128/154: Added OEM folder for Splash screen, and updated Splash screen for revised company logo
- Task 195: Corrected MS Access queries, alt summary fields with spaces in the name uses brackets correctly 
- Task 223: Added popup message when Refresh from Query Catalog is pressed from tool bar  
- Task 236: Correction to moving of INI file only for NON Vista machines  
- Task 236: INI is used from the Public folder structure on all platforms
- Task 236/237: Changed location of INI file and Log file to look in Public Documents/Global Software Inc/Executive Dash
- Task 241/300: Correction to handling of Smart Parameter with EXD from Excel with a bracketed simple list parameter  
- Task 258: Changed parameter trim for EXI to use a right trim not full trim to protect leading spaced fields 
- Task 289: Added New functioning of Tables and Named Ranges to EXD function
- Task 296: Added Oracle connection method for TCP/IP direct connect
- Task 297: Removed some obsolete items from "About" menu in Designer
- Task 302: Enhanced the logging process to use the new Log Viewer with Outlook Email Capability; Added search functionality to Log Viewer and re-worded button in settings
- Added new DSN sql syntax for Progress SQL92 PUB - adds pub. prefix to table names

V11.2.1 October 2007 
 - Corrections to spaces and numbers in table and field names
 - Corrections to Report handling
 - Added support for Excel 2007 no row limitations
 - Modified a few menus to be more user friendly
 - Corrected query locking so a query cannot be deleted without the lock un-done
 - Corrected defaulting of EXD number of records to return when starting a new query

V11.1.10 July 2007
 - More debug information with EXDs at point where dll is writing to the spreadsheet
 - Added %EXDROW% keyword gets replaced with the row number in EXD results
 - Changed error to warning when using quotes in query

V11.1.8 July 2007
 - Resolved possible issue with missing trailing \ when trying to design reports
 - Corrected issue when overriding EXQ function or field with spaces in table or field name

V11.1.7 May 2007
 - Changed name of Shortcuts in Program Menu to remove .url for the internet links

V11.1.6 May 2007
 - Changed Manual and Webex to shortcuts to url in Application folder
 - Added a temporary option to force right to left display for hebrew text

V11.1.5 May 2007
 - Corrected issue when using Parameter for library in iSeries Connections
 - Corrected issue in Formula assistant to not dump parameters to EXD if no changes made and Paste selected.
 - Corrected issue : Oracle -Added Postconnection string SQL to Excel side of EXDs connections
 - Corrected issue : Use windows login name + exd.txt for temp file to alieve file contention

V11.1.4 April 2007
 - Added SQL Server support for spaces and dashes in Database names

V11.1.3 April 2007
 - Correction: Oracle- if using an EXS by itself, no other Executive Dash formulas on a spreadsheet, the EXS now correctly opens the Oracle connection
 - Added: Export to CSV,PDF
 - Added: Button to revert back to no layout on drilldown panel
 - Added: Oracle Post Connection SQL setting in the connection and button to prebuild the text for Multi-Org Oracle Apps

V11.1.2 April 2007
 - Added recognition of MS Access datatype 7 as date type, 128 OLE Obj as Number
 - Added Date Handling of MS Access databases with smart parms
 - Removed timeout from DSN and Access queries with EXDs as its not a feature of ADODB
 - Handled a message about disposed objects when aborting a query
 - Centered Initial Drill down screen 
 - Returned mouse pointer to default if no drilldowns available
 - Changed wording on No Adhoc queries available message
 - NavBar in Drill down remembers last position in current instance.  First time its always visible in Excel
 - Corrected the text in the NavBar to change from <<< to >>> as needed.
 - Worded Export Button more toward its function.  Copy to Clipboard has ability to maintain column order, and hidden columns
  
V11.1.1 April 2007
 - New Release requires Microsoft Dotnet Framework 2.0
 - If upgrading from a previous version 11.0.x you must Uninstall the previous version and install this one
 - SoftwareKey Plus 4.4.0.3 and new Lic file used
 - New Drill Down Panels
 - Oracle Table Retrieval changed to include Owner
 - Correction: Drag and drop of field from table now build JDE precision correctly
 - Correction: Adding Field descriptions does not remove descriptions for Calculated fields
 - Corrected an slight install for DevExpress components to the GAC
 - Added SQL Timeout to EXD formulas for SQL server queries
 - Correction to smartparm handling with Wildcards with OLEDB connections
 - VS2005 Build
 - Added Mixed Regional Settings 
 - Added full "Execute If" support for Ad Hoc queries. Uses column number and value list on Ad Hoc development screen
 - Modified the EXS popup screen to allow user to select how the selected values will be inserted into the cell
 - Modified the Connections screen to re-label the Oracle connections Host to Oracle Service Name
 - Corrected issue when using EXD Fill down with Headings, fill down was filling down the heading row.
 - Modified Smart Parm Date assumptions to exclude TextField type fields
 - Increased width of select and query name boxes on Adhoc Query Development
 - Corrected issue with MS bug in formula assistant combo box not select first element in list when parsing the formula

V11.0.79 Feb 2007
 - First pass SQL Server connections with JDE Datadictionary support.  Use Database.Owner.File format for data dictionary entry on connnection.
 - Added JDE Precision support to variable total fields from EXQ 's in Excel
 - Correction to Smart Parameter range logic with text field that are used a leading zero numerics i.e. 0001.9999
 - Correction to Smart Parameter for variable total fields with spaces in field name or table name
 - Correction to Smart Parameter for AVG function,   Added TRUNC(  AVG(field), 6 ) to Oracle queries
 - Added Filter bar to Query Catalog 

V11.0.76 Jan 2007
 - Correction SQL Server queries, new menu item to create smart parm's automatically was not removing the single quotes from the alias

V11.0.75 Jan 2007
 - Added menu item to automatically create a smart parm from a selected field with an alias
 - Added support for Dynamic EXQ Function and Field, usage is  =EXQ("<queryname>|<override function>|<override field>",parm1....)
	The portion |<override function>|<override field> is optional and will change the EXQ field on the fly.  
	If omitted the defined field in the query designer will take effect
 - Redesign of Formula assistant to give Dynamic EXQ function/field parameters
 
V11.0.72 Jan 2007
 - Added Complex Bracketed Lists
 - EXD Added automatic column filldown,  Added option in Formula assistant
 - Adding Smart Parameters - BETA

V11.0.70 Jan 2007
 - Adhoc support for SSPRO
 - Corrected EXD change in 69 was clearing 1 to many columns when running
 - Changed DSN Connection to utilize the Library field to qualify fields and tables if specified in the connection

V11.0.69 Dec 2006
 - Changed EXD Function to execute from within the DLL to handle multi language unicode characters, also fixes NULL problems with left/right null values into excel

V11.0.68 Nov 2006 
 - Added more error logging
 - Added Query Timeout Setting to Settings Screen all connections except Oracle
 - Changed iSeries ODBC QSYS2 query if it fails to remove the order by and try again to get field names

V11.0.66 Nov 2006
 - Changed OLEDB on iseries to attempt to use QSYS2 tables first for schema information

V11.0.65 Nov 2006
 - Disabled JDE Field descriptions from Data dictionary for F9201 files- field does not exist in older World systems

V11.0.64 Nov 2006
 - Added More Error Checking to Oracle Field retrieval
 - Added Description to New Query Dialog box

V11.0.63 Nov 2006
  - Added storage of Autogenerated SQL to edq file.  Used internally
  - Added field descriptions with JDE Data dictionary on iSeries

V11.0.62 Aug 2006
  - Corrected tab ordering on Case builder screen
  - Removed .Net data provider added in V11.0.56 

V11.0.61 Aug 2006
  - Added table types of "T" for ODBC connections to AS400 (SQL defined tables)

V11.0.60 June 2006
  - Corrected issue with spaces in the Table Names in SQL Server Queries

V11.0.59 Feb 2006
  - Corrected issue when executing Adhoc drill downs from SQL Server Results with alias's error indicated ^ invalid
 - Added to Oracle Queries datatype recognition for NCHAR, RAW and FLOAT types. Corrects issue when using search boxs for tables with those types
 - Added All_Views to Oracle Avaliable Table listings
 - Added new Oracle Tab to Builder
 - Added Misc tab to builder 
 - Corrected Prefix/Suffix to EXQ SQL generation
 - Corrected issue when canceling or OK from adding a Calculated field, now field is not added to query if text was blank in the builder

V11.0.58 Nov 05
 - Correction to License Agreement

V11.0.57 Oct 05 
 - Enabled the Library box on connections that are DSN's
 - Added MySql as a DSN Sql Syntax,  handles alias's, and LIMIT # for Yellow/Red stoplight usage and EXD number of records to return
 - Fix when double clicking on an field in the Builder, induced in v11.0.56

V11.0.56 Sept 05
 - Added a prompt to Export CSV routine to prompt for the separator char to use.  A comma is the default response if user just clicks OK
 - Added IBM .Net Data provider as possible connection option when connecting to iSeries, req V5R3 client
 - Changed EXQ structure to ExecuteScalar instead of using dataadapter for increased speed in ODBC and .Net Provider's
 - Some minor changes to data type structures in table displays
 - Corrected support for Datatime format in field types with sql server connections
 - Slight modification to EXD iSeries ODBC command Timeout set now after connection is set to mirror Results window
 - Added more debugging information to EXD Build Detail List function

V11.0.55 Jul 05
 - m53,m54 used internally
 - Corrected a memory leak when drawing relationships between tables. Was causing a exception when many relationships or tables were used/moved around extensivlely
 - trapping added to the right click on the layout panel to get the table listing

V11.0.52 Jul 05  

 - Modify Ctrl key in formula assistant fade routine
 - Added OracleNet client for schema info in Oracle
 - Added field descriptions for oracle tables from DICT_COLUMNS
 - Added progress bar support for the oracle results
 - Changed all oracle connections to use OracleNet connector,  may require users to open their queries and then save them in the designer

V11.0.51 Jul 05
 - Added Progress bar support for iSeries,SQL Server, Oracle,  enable in the settings panel
 - Corrected a non closing connnection to the catalog when cloning

V11.0.50 Jul 05
 - Modified ExdRecordLimit in exqlmast to be Text(255) type
 - Modified the Add a parm to force upper case closer simulates the Excel parms
 - Pressing Ctrl key in formula assistant when in a parm or box for a cell toggles transparency

V11.0.49 Jul 05
- RECOMMENDED INSTALL AND CONNECTIONS TO USE ODBC for all AS400/iSeries
-   Have clients install both ODBC and OLEDB Client Access drivers when installing CA
- Added a few more data types for recognition with Oracle databases
- Added error log entry in Enhanced Logging mode when un-handled data type is encounterd
- Added - uses odbc connection for precision if the current conneciton is odbc
- Clients using data dictionary are recommended to use ODBC connection type

V11.0.48 Jul 05
 - Corrected JDE data dictionary precision to follow correctly when filtering a table with the search box

V11.0.47 Jul 05
 - Added Field descriptions to SQL Server table schemas

V11.0.46 Jun 05
 - More error logging in xml file reading for connections
 - Slight modification of connection object in designer module to exactly match dll
 - Corrected Connection Testing of SQL Server connections to match previous change Caching tables in files

V11.0.45  Jun 05
 - Corrected Parameters listing in Formula Assistant
 - Removed Sorted option from Tables in designer
 - Corrected Types not displaying correctly when filters engaged
 - Added F4 function key to cycle cell locks in formula Assistant
 - Made Formula Assistant to Stay on top of excel
 - Added with Formula Assistant User clicks to cells changes the referenced cell for parameters
 - Corrected an issue with Refreshing the Fields in SQL Server when fields are added to a table

V11.0.44 Jun 05  
 - Added %USER% is replace in all SQL statements to the current Username logged in
 - Added Tab control to select functions on builder screen between iSeries and SQL Server functions, primarly for date conversion
 - Added filter bar to results panel
 - Added Allow Nulls to all columns  -  should eliminate "Input string not in correct format" errors
 - Added Security module support - in beta
 - Added helplevel

V11.0.43 Jun 05
 - Added icon to allow user to abort executing query in Query viewer only mode
 - Error when spaces in as400 library listings "lib1, lib2"  is now rectified when selecting a library from the Change Library menu

V11.0.42 Jun 05  
 - Added setting for Enable Designer in settings
 - Added View Query Only panel when Enable Designer disabled
 - Corrected parsing of old odbc connection string for password introduced in .39
 
v11.0.41 May 05 
 - Modified the AdHoc Drilldown building panel
 - Added double click from results panel brings up adhoc selector
 - Corrected action when aborting the closing of the query designer
 - Added Adhoc drill down capability to Results panel - IN BETA STATUS

V11.0.40 May 05
 - More error checking added to EXQ functions with Extended logging
 - Corrected a double login introduced in 39
 
V11.0.39 May 05 

 - Added Translate=1 option into ODBC connection string to correct ByteData in EXS box
 - Modified EXS to leave numbers with leading 0's as strings, format the cell to text and 001 will appear instead of 1
 - Changed color of Table Search box to a blue not the Active Caption to avoid poor looking displays on different windows styles
 - Modified the location of language resource file loading to enable error logging on startup
 - Removed writes to the Registry from Designer 
 - Added debug option to the ini file and settings provides enhanced error logging when set to true

V11.0.38 May 05 
 - Modified the Builder to allow ":"'s in the text of the builder
 - Modified the Copy to clipboard/excel when results are grouped to hit correct row
 - Re-work of Tablename format for SQL Server Queries, Refresh the Table listing to add Owner.Tablename to list of available table in SQL Server.  This allows user to access a table owned by someone other than the user and dbo.
 - Added some additional error messages to License check

 
V11.0.37 May 05
  -Modified the Schema calls for SQL Server connections
  -Added Table Caching to SQL Server
  -Removed MDAC from install

V11.0.36 May 05
 - Added a Search box to the top of every Table in the layout screen, searches field and description for text
 - Added a Search box to the Builder  (Calc fields/criteria) to search for field names from name or description
 - Corrected the Alias issue when selecting fields from a sorted table
 
V11.0.35 Apr05
 - Added button to convert iSeries 7 digit Julian date (YYYYddd) to date field
 - Cleaned exiting from Splash Screen

V11.0.34 Apr 05
 - Changed EXS with ODBC to not use string converter
 - Added splash screen with lic check to front end of designer

V11.0.33 Apr 05
 - Added CPTolerence = 500
 - Added error logging on initial Query Designer start up
 - Changed EXD with ODBC to not use OLEDB String Converter
 - Added more Query Changed = true when modifying parameters
 - Added Splash Screen
 - Prevent Click thru on lic check

V11.0.32 Apr 2005
 - Added UID and PWD to All DSN connections if uid and pwd specified in the connnection

V11.0.31 Apr 2005
 - Modified Table and field retrieval with ODBC to use QSYS2 library info and odbc connection
 - New SKCL.dll 4.2.1.9 allows registration on XP Pro SP2 with New NX intel/amd cpu hardware flags
 - XP Pro SP2 with New Hardware requires ODBC connection types due to IBMDA400 provider not registering correctly with Client Access
 - Removed Save As function.  Use Clone Query
 - Embedded Error checking to EDash Error log file
 - Prevent changing a query name during initial save, prevents out of sync catalog names
 - Added positioning within the catalog by pressing any letter takes you to the first query starting with that letter

V11.0.30 Mar 2005
 - Added option to Trim fields in a relationship between tables, no error checking
 - Added catalog/database selection for SQL Server databases
 - Corrected DSN connections to select correct syntax from list box 
 - SQL Syntax DSN's allow the addition of username and password if left blank assumes windows user authentication and requires that windows user to have an account on the SQL server.
 - Added version number inserted to install log files.

V11.0.29 Feb 2004 - 
 - Added ability to add multiple queries to the current catalog from the File Menu
 - Pressing Del key with a query higlighted will begin the delete query function
 - Table names are cached for each Connection/Library combination
 - Filtering provided in add Table selector panel

V11.0.28 Feb 2004 - 
 - Autosize button added to results panel
 - Export to CSV or Text file added as right click menu option on results panel.  Will create multiple files if 
 -  user requests in CSV files or if > 64k rows and no multiple file a  .txt file is created
 - Fixed pressing Cancel when executing a query with the prompt for number of records to return
 - Added new buttons in the builder to format dates and some other common functions
 - Added CASE Statement builder
 - Added Export with formatting to PDF, XLS, RTF from query results window
 - Layouts in results window can be saved and deleted, stored in folder with catalog
 - Right click in Catalog selects the line under the mouse then shows context menu

v11.0.27 Dec 2004
 - Added ODBC conversions for tables when selecting values from builder panel
 - corrected IN statement in builder panel when no values are selected
 - Enhanced error message when FETCH is not supported
 - Hid Connection string on Connections Management panel
 - Fixed default for not prompting on SQL Server/Access/Oracle
 - Added sql text to Query Textual Description
 - Changed main screen to be maximized upon open
 - Added About Form with link to product updates

v11.0.26 Oct 2004
 - Added international list separator support to Formula Assistant
 - Corrected the parsing of a current EXD formula to get the Clear Range parameter in an existing
   formula into the formula Assistant
 - Corrected In statement from EXS with numeric data
 - Corrected EXS error with ODBC connections
 - Corrected possible corrupted connections file when saving a new connection with the Lib blank
 - Changed the default for AS400/iSeries to be promped connections

v11.0.25 Oct 2004
 - Upgraded Treegrid component was not being registered correctly in v11.0.24.  This fixes that
   registration.

V11.0.24 Oct 2004
 - Updated EXS window to use IN(XX) statements with OK button, individual value with doubleclick
 - Updated parameters to allow testing of IN statements with embedded strings using single quotes
 - Updated sort orders with numeric data vs alpha-numeric data in results window

V11.0.23 Sept 2004
 - Added ability to use shared connections co-located in the EXQLMAST location
 - Added it-IT.resources to Installation for Italian language support

V11.0.22 Sept 2004
 - Minor screen corrections on Formula Assistant

V11.0.21 Sept 2004
 - Added Redesigned Formula Assistant
 - Minor correction to EXS query use on SQL Server connected queries
 - Added auto space addition to carriage returns in Builder

V11.0.20 Sept 2004
 - Added Sql Syntax selection for DSN connections
 - Added Textual Description option under Query menu Item
 - Added 4 new buttons into Builder screen for Date, Trim, IN, and Between
 - Locked any query execution to start with "SELECT"

V11.0.19 Aug 2004
 - Initial implementation of direct ODBC connections to Oracle8i and later database

V11.0.18 Aug 2004
 - Corrected SQLBuild issue with AS400 Series calculated fields removing a pair of []'s
 - Finished the correction to the Save As.

V11.0.17 Aug 2004
 - Corrected Error in Save As function
 - Correction to Panel layout occasionaly displaying Red X,when cloning a query

V11.0.16 Aug 2004
 - Enhanced All window bounds to save layout of panels on screen when application is closed
 - Added splitter/sizeable Parameters panel
 - Included new xla
V11.0.15 Aug 2004
 - Restricted Connection Management screen enabled fields to prevent errors on entry
 - Added a Change Library menu item when right clicking on a table to ease distribution of templated queries
 - Corrected an Object Not Found Error when using a brand new connection before closing and re-opening

V11.0.14 Aug 2004
 - Added new drag and drop support for field order in selected field panel
 - Corrected MS-Access queries with dashes vs calculated field subtraction in SQL generator

V11.0.13 Aug 2004
 - Corrected EXD String conversion with iSeries via ODBC connections
 - Trimmed length of automatic descriptions as aliases for iSeries to 29 Characters
 - Corrected MS-Access queries with dashes in Table and field names
 - Corrected MS-Access queries displaying Currency Type as a number
 - Changed parameters to remove leading and trailing single quotes
 - Added .resourse support for English and Spanish, disabled in menu until complete

V11.0.12 July 2004
 - Minor menu revisions

V11.0.11 July 2004
 - Added, EXD formula, you can now provide a Range "A2:b4" to the parameter Clear sheet instead of a Y or N.
 - Corrected error when attempting to save a query with a blank in the number of records to return.

V11.0.10 July 2004
 - Added a new connection type via ODBC to an iSeries/AS400, in testing yields a 50% improvement in detail query performance over OLE DB
 - Added feature to automatically set all aliases to the field description on the right click menu over the selected fields panel
 - Corrected an issue in non-prompted connections not setting the correct lib

V11.0.8 July 2004
 - Modified sorting of table listing to occur after loading

V11.0.7 Jun 2004
 - Corrected an error in the Autogenerate of SQL when a sort order was specified on a field using a function in the Groupby Column.
 - Disabled the viewing of the SQL Connection string during testing if CBS is enabled.
 - When adding a table the table listing is now sorted 

V11.0.6 Jun 2004
 - Added function =EXS("QueryName","Text for this cell", Cell for selected value, P01,P02 .....)
   Right click on this cell and select "Query Select (EXS) from the menu acts as a look up query
   placing the selected value into a cell.  Only enters the first columns value to the cell but
   displays all the fields of the query in the lookup box

V11.0.5 Jun 2004
 - Added grouping support for Catalog view

V11.0.4 Jun 2004
 - Corrected SQL Generation for Totaling queries

V11.0.3 Jun 2004
 - Correction to Connection string Cache
 - Corrected Parameters with commas in the text
 - Corrected saveing parameter default values with single quote in text

V11.0.2 Jun 2004
 - Added: In the Results window right click on a field/column header and select Sum by group
   will display summaries for that column based on groupings set.  Rearanging columns prior 
   to selecting sum by group will produce inconsistant results.
 - Corrected entrance to Criteria Builder for Criteria 2-7
 - Changed focus to remain on selected item in catalog after a refresh of the catalog
 - Changed focus of Selected fields to remain after change in a criteria
 - Corrected an offset of precision in JDE Datadicionary applied precision

V11.0.1 Jun 2004
 - Addition of Data Dictionary Use on iSeries
 - Corrected SQL EXQ Generation with multiple joins between 2 tables
 - Modified disconnect of open connections

v11.0.0 New redesigned version of Designer and Addin
